Along the lines of auditing a worksheets you're going to run into scenarios where you've got calculations
that span across multiple worksheets.
And if I want to build something that moves across multiple worksheets I need a way to build to keep
an eye on one worksheet and perhaps a value on one worksheet while I work on other worksheets.
Now in the past if I were to do something like this take a look I've got the example file open I'm on
the watch window worksheet and this cell right here this hundred seventy six thousand two hundred eleven
dollars is actually a reference to another cell.
I look at my formula bar here at the top that lives on the worksheet next door called formula auditing
it's referencing cell f 10 on the formula auditing worksheet.
Now I want to keep an eye on this value here as I change things on the formula auditing worksheet.
So I jump in the here I make a change and see I changed the 16 900 to 7000 in my enter key and now I
got to jump back to my watch window worksheet and notice oh it went up by 100 bucks from 176 to 11 to
176 311.
So now I'm doing this kind of back and forth game to keep an eye on this value here as I make adjustments
in other locations that affect the sell that back and forth very manual something I really don't want
to do but it's something that we probably do again and again now rather than that back and forth game
where you take a look at a feature here that's called the watch window.
It's going to allow us to open up a separate window mark a cell such as beat to hear this hundred seventy
six thousand market as a cell that I want to watch as I work in other worksheets.
Take a look.
This is super simple.
So I'm on the watch window worksheet.
I'm going to select cell BE2.
I've got it selected there.
I mean I got my formula down inside the formula auditing section.
I'm going to go to the watch window looks like a little box with the pair of glasses.
I'll give that a click.
This opens up my watch window.
I currently don't have anything in there so I'm going to add a watch and it wants to know.
Well hey.
Which cell do you want to watch.
Which one you want to tag that you can continue to watch as you work inside of other worksheets.
Well I've already had two selected.
So it's got it there.
I'm going hit add and I've now got reference to that cell.
I can see that it's inside of this workbook it's on this she called the watch window sheet at Selby
2.
It's currently got a value of 176 311.
And here is the formula that makes up that that value.
Now this window's always open now.
I hop over to formula auditing.
I make a change.
Let's say I go from 7000 back to sixty nine hundred.
Now watch this window over here is the watch with no rights watch this value.
I mean to hit my enter key and rather than having to go back to the watch when the worksheet to check
the update I can just see it right here.
Now we're back to 176 to 11.
Really simple.
Select the cell that you want to watch as you work in other worksheets.
Open up though and watch when you add a watch you've now marked that cell.
And now as you work in other locations within these more complex larger Excel documents and get updates
and I can watch those cells that are important to me.
So another technique to help us audit these larger Excel workbooks.
Try this out.
Open up the example file and watch.
Jumping over to the watch window and went to that cell and then go back and make some adjustments on
the formula auditing worksheet and use our watch window to help you keep an eye on those cells.
And the values that you're looking at try out